Tabela ContractDataHist

Definicja tabeli ContractDataHist

Name

ContractDataHist

Code

ContractDataHist

Comment

Historyczne wpisy zawierajace stan danych wszystkich kolumn tabeli ContractData.


Lista kolumn tabeli ContractDataHist

Name

Code

ContractDataHistID

ContractDataHistID

ContractServiceKindID

ContractServiceKindID

DateRestrictionID

DateRestrictionID

RatioSchemaID

RatioSchemaID

AccountingSchemaID

AccountingSchemaID

ContractID

ContractID

OrgUnitID

OrgUnitID

ContractDataID

ContractDataID

UnitsCount

UnitsCount

Price

Price

StartDT

StartDT

StopDT

StopDT

Active

Active

PreviousPrice

PreviousPrice

PreviousUnitsCount

PreviousUnitsCount

AccountingPeriodID

AccountingPeriodID

ReportingPeriodID

ReportingPeriodID

PriceRatio

PriceRatio

PackageID

PackageID

GrouperVersionNo

GrouperVersionNo

PositionGroupNo

PositionGroupNo

Month

Month

Year

Year

RealPrice

RealPrice

PerfUnitsCount

PerfUnitsCount

KindOfPeriod

KindOfPeriod

NumberOfPeriod

NumberOfPeriod

Quantity

Quantity

Refund

Refund

RegionCode

RegionCode

AccountingPeriodMonthFrom

AccountingPeriodMonthFrom

AccountingPeriodMonthTo

AccountingPeriodMonthTo

VatRate

VatRate

VatMultiplier

VatMultiplier

AnexID

AnexID

LumpSumContractServId

LumpSumContractServId


Kolumna ContractDataHistID tabeli ContractDataHist

Definicja kolumny ContractDataHistID tabeli ContractDataHist

Name

ContractDataHistID

Code

ContractDataHistID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractServiceKindID tabeli ContractDataHist

Definicja kolumny ContractServiceKindID tabeli ContractDataHist

Name

ContractServiceKindID

Code

ContractServiceKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DateRestrictionID tabeli ContractDataHist

Definicja kolumny DateRestrictionID tabeli ContractDataHist

Name

DateRestrictionID

Code

DateRestrictionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RatioSchemaID tabeli ContractDataHist

Definicja kolumny RatioSchemaID tabeli ContractDataHist

Name

RatioSchemaID

Code

RatioSchemaID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountingSchemaID tabeli ContractDataHist

Definicja kolumny AccountingSchemaID tabeli ContractDataHist

Name

AccountingSchemaID

Code

AccountingSchemaID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractID tabeli ContractDataHist

Definicja kolumny ContractID tabeli ContractDataHist

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrgUnitID tabeli ContractDataHist

Definicja kolumny OrgUnitID tabeli ContractDataHist

Name

OrgUnitID

Code

OrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractDataID tabeli ContractDataHist

Definicja kolumny ContractDataID tabeli ContractDataHist

Name

ContractDataID

Code

ContractDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitsCount tabeli ContractDataHist

Definicja kolumny UnitsCount tabeli ContractDataHist

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

liczba rozl. jedn. miary zawartych w jednym opakowaniu


Kolumna Price tabeli ContractDataHist

Definicja kolumny Price tabeli ContractDataHist

Name

Price

Code

Price

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ContractDataHist

Definicja kolumny StartDT tabeli ContractDataHist

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Poczatek obowiazywania taryfy


Kolumna StopDT tabeli ContractDataHist

Definicja kolumny StopDT tabeli ContractDataHist

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Koniec obowiazywania taryfy


Kolumna Active tabeli ContractDataHist

Definicja kolumny Active tabeli ContractDataHist

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy dany wpis jest aktywny


Kolumna PreviousPrice tabeli ContractDataHist

Definicja kolumny PreviousPrice tabeli ContractDataHist

Name

PreviousPrice

Code

PreviousPrice

Data Type

NUMBER(22,6)

Mandatory

No

Comment

 


Kolumna PreviousUnitsCount tabeli ContractDataHist

Definicja kolumny PreviousUnitsCount tabeli ContractDataHist

Name

PreviousUnitsCount

Code

PreviousUnitsCount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna AccountingPeriodID tabeli ContractDataHist

Definicja kolumny AccountingPeriodID tabeli ContractDataHist

Name

AccountingPeriodID

Code

AccountingPeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReportingPeriodID tabeli ContractDataHist

Definicja kolumny ReportingPeriodID tabeli ContractDataHist

Name

ReportingPeriodID

Code

ReportingPeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PriceRatio tabeli ContractDataHist

Definicja kolumny PriceRatio tabeli ContractDataHist

Name

PriceRatio

Code

PriceRatio

Data Type

NUMBER(8,4)

Mandatory

No

Comment

 


Kolumna PackageID tabeli ContractDataHist

Definicja kolumny PackageID tabeli ContractDataHist

Name

PackageID

Code

PackageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GrouperVersionNo tabeli ContractDataHist

Definicja kolumny GrouperVersionNo tabeli ContractDataHist

Name

GrouperVersionNo

Code

GrouperVersionNo

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna PositionGroupNo tabeli ContractDataHist

Definicja kolumny PositionGroupNo tabeli ContractDataHist

Name

PositionGroupNo

Code

PositionGroupNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Month tabeli ContractDataHist

Definicja kolumny Month tabeli ContractDataHist

Name

Month

Code

Month

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Year tabeli ContractDataHist

Definicja kolumny Year tabeli ContractDataHist

Name

Year

Code

Year

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna RealPrice tabeli ContractDataHist

Definicja kolumny RealPrice tabeli ContractDataHist

Name

RealPrice

Code

RealPrice

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna PerfUnitsCount tabeli ContractDataHist

Definicja kolumny PerfUnitsCount tabeli ContractDataHist

Name

PerfUnitsCount

Code

PerfUnitsCount

Data Type

NUMBER(14,4)

Mandatory

No

Comment

 


Kolumna KindOfPeriod tabeli ContractDataHist

Definicja kolumny KindOfPeriod tabeli ContractDataHist

Name

KindOfPeriod

Code

KindOfPeriod

Data Type

VARCHAR2(2)

Mandatory

No

Comment

 


Kolumna NumberOfPeriod tabeli ContractDataHist

Definicja kolumny NumberOfPeriod tabeli ContractDataHist

Name

NumberOfPeriod

Code

NumberOfPeriod

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Quantity tabeli ContractDataHist

Definicja kolumny Quantity tabeli ContractDataHist

Name

Quantity

Code

Quantity

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Refund tabeli ContractDataHist

Definicja kolumny Refund tabeli ContractDataHist

Name

Refund

Code

Refund

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna RegionCode tabeli ContractDataHist

Definicja kolumny RegionCode tabeli ContractDataHist

Name

RegionCode

Code

RegionCode

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna AccountingPeriodMonthFrom tabeli ContractDataHist

Definicja kolumny AccountingPeriodMonthFrom tabeli ContractDataHist

Name

AccountingPeriodMonthFrom

Code

AccountingPeriodMonthFrom

Data Type

NUMBER(5)

Mandatory

No

Comment

Miesiac poczatku okresu rozliczeniowego


Kolumna AccountingPeriodMonthTo tabeli ContractDataHist

Definicja kolumny AccountingPeriodMonthTo tabeli ContractDataHist

Name

AccountingPeriodMonthTo

Code

AccountingPeriodMonthTo

Data Type

NUMBER(5)

Mandatory

No

Comment

Miesiac konca okresu rozliczeniowego


Kolumna VatRate tabeli ContractDataHist

Definicja kolumny VatRate tabeli ContractDataHist

Name

VatRate

Code

VatRate

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna VatMultiplier tabeli ContractDataHist

Definicja kolumny VatMultiplier tabeli ContractDataHist

Name

VatMultiplier

Code

VatMultiplier

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna AnexID tabeli ContractDataHist

Definicja kolumny AnexID tabeli ContractDataHist

Name

AnexID

Code

AnexID

Data Type

NUMBER(10)

Mandatory

No

Comment

Id ostatniego kontraktu, który spowodowal zmiane danych na ContractData


Kolumna LumpSumContractServId tabeli ContractDataHist

Definicja kolumny LumpSumContractServId tabeli ContractDataHist

Name

LumpSumContractServId

Code

LumpSumContractServId

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli ContractDataHist

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractDataHist

Definicja klucza Identifier_1 tabeli ContractDataHist

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment